package com.monitor.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.monitor.entity.ErpMaterielCopy;


/**
 * <p>
 * 物料表 Mapper 接口
 * </p>
 *
 * @author LX
 * @since 2018-09-08
 */
public interface ErpMaterielCopyMapper extends BaseMapper<ErpMaterielCopy> {
	@Select("SELECT m.corresponding_id from erp_materiel_copy m where m.warehouse_id in (${warId}) and m.materiel_name=#{mat.materielName}	and m.materiel_brand=#{mat.materielBrand} and m.materiel_specifications=#{mat.materielSpecifications} and m.materiel_model=#{mat.materielModel} and m.materiel_place=#{mat.materielPlace} and m.materiel_state=#{mat.materielState} and m.materiel_unit=#{mat.materielUnit} and m.materiel_load=0 and m.materiel_production_id in (${sheng})")
	public List<Integer> selectProductionIds(@Param("warId")String warId,@Param("mat")ErpMaterielCopy mat,@Param("sheng")String sheng);
}
